Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TelephoneID (PK) | A unique system assigned identifier for this Telephone number | ID_PH | Identity | integer | |
ITUCountryCode (FK) | A 1 - 3 digit telephone number dialling code denoting a Country or similar locality as assigned by the International Telgraphic Union (ITU). | CD_CY_ITU | PhoneNumberCountryCode | char(3) | ITUCountry(LO_CY_ITU) |
AreaCode | The 1 - 6 digit area code that further categorizes the Telephone with it's Country. | TA_PH | PhoneNumberAreaCode | char(5) | |
TelephoneNumber | The 5 - 8 digit number for the Telephone within the confines of the ITUCountryCode and AreaCode. | TL_PH | PhoneNumberLocal | varchar(20) | |
ExtensionNumber | Addtional numbers required to reach a Party's Telephone or voice mailbox. | PH_EXTN | PhoneNumberExtension | char(5) | |
CompleteNumber | The complete telephone number including the CountryCode, AreaCode, Telephone Number and ExtensionNumber. | PH_CMPL | PhoneNumberComplete | varchar(32) | |